FundFlow Viz 1 asks: WHICH WAY? HOW MUCH? HOW FAST (ACCELERATING; DECELERATING)?
Description of "$Prices - Flows"
Rate $Chg broken down by Measure Names vs. Date, sum of %Chg Mkt and sum of Wkly Flows. Color shows details about Trend (Rate of Chg).
Marks
The mark type is Text. |
Stacked marks is on. |
Shelves
Rows: |
Date, %Chg Mkt, Wkly Flows |
Columns: |
Measure Names |
Filters: |
Measure Names |
Text: |
Rate $Chg |
Color: |
Trend (Rate of Chg) |
Dimensions
Measure Names has 1 members on this sheet
Members: Rate $Chg
Date has 769 members on this sheet
Members: 1/15/1992; 1/22/1992; 1/29/1992; 1/8/1992; 2/5/1992; ...
Date is sorted in descending natural order.
Measures
Sum of %Chg Mkt has 456 members on this sheet
Members: -1.08; -1.14; 0.93; 1.1; 1.79; ...
Sum of Wkly Flows has 769 members on this sheet
Members: 1,989,688.14249994; 2,625,338.85613247; 3,409,190.91937538; 499,714.426179822; 652,460.91307165; ...
Rate $Chg ranges from -4,243,492 to 8,162,630 on this sheet.
The formula is CASE [Buy Sell Rate of Change]
WHEN "4-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -3, 0)
WHEN "5-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -4, 0)
WHEN "6-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -5, 0)
WHEN "7-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -6, 0)
WHEN "8-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -7, 0)
WHEN "9-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -8, 0)
WHEN "10-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -9, 0)
WHEN "11-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -10, 0)
WHEN "12-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -11, 0)
WHEN "13-WK SMA" THEN WINDOW_AVG(SUM([Wkly Flows]), -12, 0)
END
Results are computed along Date (sorted ascending by Count of Date).
Trend (Rate of Chg) has 2 members on this sheet
Members: Decreasing; Increasing
The formula is If ZN(([Rate $Chg])) - LOOKUP(ZN(([Rate $Chg])), -1)> 0 THEN "Increasing" Else "Decreasing" END
Results are computed along Date (sorted ascending by Count of Date).
For Rate $Chg, results are computed for each Date.
Trend (Rate of Chg) is sorted manually.
Data Source Details
Data Source: |
AMGDEMO EQxETF |
Type: |
Tableau Data Engine Database |
Database: |
C:/Users/bob/AppData/Local/Temp/TableauTemp/30082704/Data/Datasources/AMGDEMO EQxETF.tde |
Table: |
Extract (Extract.Extract) |